Diagram SCHED_Visit

Defincja diagramu SCHED_Visit

Name

SCHED_Visit

Code

SCHED_Visit

Comment

 


Lista tabel diagramu

Name

Code

ActionType

ActionType

CancelData

CancelData

CategoryDictionary

CategoryDictionary

DictionaryValue

DictionaryValue

EPortalPatientReferral

EPortalPatientReferral

Event

Event

ExternalDoctor

ExternalDoctor

ExternalOrgUnit

ExternalOrgUnit

ICD

ICD

Language

Language

LPerfServiceReservation

LPerfServiceReservation

LPerfServiceTimeSlot

LPerfServiceTimeSlot

LVisitPerfService

LVisitPerfService

LVisitStatus

LVisitStatus

LVisitTimeSlot

LVisitTimeSlot

MedResource

MedResource

Patient

Patient

PerfService

PerfService

Person

Person

PreviousTreatmentPlace

PreviousTreatmentPlace

Referral

Referral

ReferralMode

ReferralMode

ReferralSource

ReferralSource

Reservation

Reservation

ReservationType

ReservationType

ReservationTypeText

ReservationTypeText

Service

Service

StatCode8thPart

StatCode8thPart

StatCode8thPartText

StatCode8thPartText

TimeSlot

TimeSlot

UserDefinition

UserDefinition

Visit

Visit

VisitCancelReason

VisitCancelReason

VisitQueueItem

VisitQueueItem

VisitSource

VisitSource

VisitSourceText

VisitSourceText

VisitStatus

VisitStatus

VisitStatusText

VisitStatusText

VisitType

VisitType

VisitTypeText

VisitTypeText

WaitingListItem

WaitingListItem


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

I_1

I_1

Person

UserDefinition

PersonID

 

 

R_172

R_172

Visit

LVisitPerfService

VisitID

 

 

R_173

R_173

PerfService

LVisitPerfService

PerfServiceID

 

 

R_351

R_351

Language

UserDefinition

LanguageID

 

 

R_368

R_368

Event

Visit

EventID

 

 

R_392

R_392

Visit

LVisitTimeSlot

VisitID

 

 

R_393

R_393

TimeSlot

LVisitTimeSlot

TimeSlotID

 

 

R_394

R_394

Patient

Visit

PersonID

 

 

R_396

R_396

Language

VisitTypeText

LanguageID

 

 

R_404

R_404

VisitStatus

LVisitStatus

VisitStatusID

 

 

R_405

R_405

Visit

LVisitStatus

VisitID

 

 

R_411

R_411

VisitType

Visit

VisitTypeID

 

 

R_412

R_412

VisitStatus

VisitStatusText

VisitStatusID

 

 

R_413

R_413

VisitType

VisitTypeText

VisitTypeID

 

 

R_414

R_414

Language

VisitStatusText

LanguageID

 

 

R_516

R_516

Visit

CancelData

VisitID

 

 

R_518

R_518

MedResource

CancelData

MedResourceID

 

 

R_1102

R_1102

TimeSlot

LPerfServiceTimeSlot

TimeSlotID

 

 

R_1103

R_1103

PerfService

LPerfServiceTimeSlot

PerfServiceID

 

 

R_1139

R_1139

UserDefinition

LVisitStatus

PersonID

 

 

R_1952

R_1952

VisitStatus

Visit

VisitStatusID

 

 

R_1960

R_1960

Reservation

Visit

ReservationID

 

 

R_2091

R_2091

ExternalDoctor

Referral

ReferralDoctorID

 

 

R_4010

R_4010

Referral

Visit

ReferralID

 

 

R_8450

R_8450

VisitCancelReason

LVisitStatus

VisitCancelReasonID

 

 

R_9091

R_9091

VisitSource

VisitSourceText

VisitSourceID

 

 

R_9092

R_9092

VisitSource

Visit

VisitSourceID

 

 

R_9232

R_9232

Referral

Reservation

ReferralID

 

 

R_9234

R_9234

ReservationType

ReservationTypeText

ReservationTypeID

 

 

R_9235

R_9235

ReservationType

Reservation

ReservationTypeID

 

 

R_9236

R_9236

StatCode8thPart

StatCode8thPartText

StatCode8thPartID

 

 

R_9237

R_9237

StatCode8thPart

Referral

StatCode8thPartID

 

 

R_9238

R_9238

Person

Referral

PersonID

 

 

R_9239

R_9239

Reservation

WaitingListItem

ReservationID

 

 

R_9579

R_9579

DictionaryValue

Visit

ContinuationOfTreatmentID

 

 

R_9834

R_9834

Reservation

LPerfServiceReservation

ReservationID

 

 

R_9835

R_9835

PerfService

LPerfServiceReservation

PerfServiceID

 

 

R_10153

R_10153

CategoryDictionary

Referral

HospitalizationPurposeID

 

 

R_10331

R_10331

Visit

VisitQueueItem

VisitID